class CreateCustomers < ActiveRecord::Migration
  def change
    create_table :customers do |t|
      t.integer :customer_level_id
      t.string :name
      t.string :phone
      t.string :car_num
      t.string :car_mo
      t.string :car_colour
      t.string :car_fnum
      t.string :car_enum
      t.integer :car_brand_id
      t.integer :car_model_id
      t.string :telephone
      t.string :age
      t.string :id_num
      t.string :customer_source
      t.string :qq
      t.date :birthday
      t.string :addr
      t.string :customer_type
      t.string :email
      t.string :occupation
      t.string :zip_code
      t.string :sex
      t.date :driving_expire
      t.string :fax
      t.date :of_date
      t.date :buy_date
      t.date :force_expire
      t.date :commercial_expire
      t.date :last_cf_date
      t.string :last_cf_mileage
      t.date :last_care_date
      t.string :last_care_mileage
      t.string :fix_care_mileage
      t.string :fix_care_cycle
      t.date :next_care_date
      t.string :next_care_mileage
      t.integer :insurer_id
      t.date :year_inspect_date
      t.string :active_status
      t.string :oil_meter


      t.timestamps null: false
    end
  end
end
